<? $section='Users'; ?>
<?
	require_once 'inc/functions.php';
	$conn = getConnection();
	//print_r($conn);
		$result = $conn->query('SELECT * FROM 2011_Users');
		
?>

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Home</title>
</head>

<body bgcolor="#333333">
<h1><img src="logo.png" alt="Logo" width="619" height="117" /></h1>
<? include("inc/tabs.php"); ?>
<div class="content">
<h1>Users</h1>

<table border ="1">
	<tr>
		<th>FirstName</th>
		<th>LastName</th>
        <th>ID</th>
        <th>Lookup ID</th>
        <th>Password</th>
        <th>Picture URL</th>
        <th>Facebook ID</th>
        <th>Created At</th>
        <th>Updated At</th>
	</tr>
    
<? while($rs = $result->fetch_assoc()) { ?>
     <tr>
     <td><?=$rs['FirstName']?></td>
     <td><?=$rs['LastName']?></td>
     <td><?=$rs['id']?></td>
     <td><?=$rs['Lookup_id']?></td>
     <? if($rs['Password']==NULL) { ?>
	  <td><?= 'NULL' ?></td>
	 <? }else{ ?>
     <td><?=$rs['Password']?></td>
     <? } ?>
	     <? if($rs['PictureURL']==NULL) { ?>
	  <td><?= 'NULL' ?></td>
	 <? }else{ ?>
     <td><?=$rs['PictureURL']?></td>
     <? } ?>
          <? if($rs['FBID']==NULL) { ?>
	  <td><?= 'NULL' ?></td>
	 <? }else{ ?>
     <td><?=$rs['FBID']?></td>
     <? } ?>
     <td><?=$rs['created_at']?></td>
     <td><?=$rs['updated_at']?></td>
     </tr>
<? } ?>
</table>
</div>
</body>
</html>

<? $conn->close(); ?>